-
Re: Group Columns in Grid
Add feature to group columns (like MS Excel has) - Can save some horizontal scrolling and will help displaying columns on need basis.11 · -
Re: #invalid Column Value Error
Assuming you Site Names are unique in the lookup sheet, you can use the formula below (Please make sure the formula column aka NTP Status in your case, has been defined as Date column) =IFERROR(INDEX…1 · -
Re: IF Statement involving columns in two separate sheets, with a return response from a date column
Try this: =IFERROR(INDEX(COLLECT({COI Vendors Range 3}, {COI Vendors Range 1}, HAS(@cell, [Vendor ID]@row)), 1), "No Match")1 · -
Re: Multiple IF and IF (AND) arguments in one formula
You have extra closing brackets in your formula. Try the below, =IF(AND([VO Feed status]@row = "VO: Pending file receipt", [QA Feed Status]@row = "QA: feed aligned to sprint"), &q…1 · -
Re: Dates in a column
If you are not looking for a Column Formula then does the simple workaround of adding the formula =[Start Date]1 + 3, work for you? All you have to do is just drag the formula when you add new rows.1 ·